Waze raw Profiling Report

Dataset statistics

Number of variables	19
Number of observations	18287
Missing cells	83301
Missing cells (%)	24.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.7 MiB
Average record size in memory	152.0 B

Variable types

Numeric	8
Categorical	7
DateTime	1
Unsupported	3

Alerts

`linqmap_reportMood` has constant value "0"	Constant
`nComments` has constant value "0"	Constant
`linqmap_city` has a high cardinality: 77 distinct values	High cardinality
`linqmap_street` has a high cardinality: 1208 distinct values	High cardinality
`linqmap_roadType` is highly correlated with `linqmap_reportRating`	High correlation
`linqmap_reportRating` is highly correlated with `linqmap_roadType` and 1 other fields	High correlation
`linqmap_magvar` is highly correlated with `linqmap_reportRating`	High correlation
`linqmap_reportRating` is highly correlated with `linqmap_magvar`	High correlation
`linqmap_magvar` is highly correlated with `linqmap_reportRating`	High correlation
`OBJECTID` is highly correlated with `update_date`	High correlation
`linqmap_reportRating` is highly correlated with `linqmap_magvar`	High correlation
`linqmap_magvar` is highly correlated with `linqmap_reportRating`	High correlation
`update_date` is highly correlated with `OBJECTID`	High correlation
`linqmap_city` is highly correlated with `linqmap_reportDescription` and 2 other fields	High correlation
`linqmap_reportDescription` is highly correlated with `linqmap_city` and 4 other fields	High correlation
`linqmap_type` is highly correlated with `linqmap_reportDescription` and 3 other fields	High correlation
`nComments` is highly correlated with `linqmap_city` and 4 other fields	High correlation
`linqmap_subtype` is highly correlated with `linqmap_reportDescription` and 3 other fields	High correlation
`linqmap_reportMood` is highly correlated with `linqmap_city` and 4 other fields	High correlation
`OBJECTID` is highly correlated with `update_date`	High correlation
`linqmap_type` is highly correlated with `linqmap_subtype` and 4 other fields	High correlation
`linqmap_subtype` is highly correlated with `linqmap_type` and 5 other fields	High correlation
`linqmap_reportDescription` is highly correlated with `linqmap_magvar`	High correlation
`linqmap_city` is highly correlated with `linqmap_type` and 7 other fields	High correlation
`linqmap_roadType` is highly correlated with `linqmap_subtype` and 1 other fields	High correlation
`linqmap_reportRating` is highly correlated with `linqmap_type` and 4 other fields	High correlation
`linqmap_magvar` is highly correlated with `linqmap_type` and 4 other fields	High correlation
`linqmap_reliability` is highly correlated with `linqmap_type` and 3 other fields	High correlation
`update_date` is highly correlated with `OBJECTID`	High correlation
`x` is highly correlated with `linqmap_city` and 1 other fields	High correlation
`y` is highly correlated with `linqmap_city` and 1 other fields	High correlation
`linqmap_subtype` has 907 (5.0%) missing values	Missing
`linqmap_reportDescription` has 17949 (98.2%) missing values	Missing
`linqmap_city` has 7850 (42.9%) missing values	Missing
`linqmap_street` has 1734 (9.5%) missing values	Missing
`linqmap_nearby` has 18287 (100.0%) missing values	Missing
`linqmap_expectedBeginDate` has 18287 (100.0%) missing values	Missing
`linqmap_expectedEndDate` has 18287 (100.0%) missing values	Missing
`linqmap_nearby` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`linqmap_expectedBeginDate` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`linqmap_expectedEndDate` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`linqmap_roadType` has 333 (1.8%) zeros	Zeros
`linqmap_reportRating` has 7011 (38.3%) zeros	Zeros
`linqmap_magvar` has 7086 (38.7%) zeros	Zeros

Reproduction

Analysis started	2022-06-02 08:41:46.363205
Analysis finished	2022-06-02 08:41:58.704680
Duration	12.34 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

OBJECTID
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	17133
Distinct (%)	93.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116434.9893

Minimum	12568
Maximum	187271
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	143.0 KiB

Quantile statistics

Minimum	12568
5-th percentile	16550.3
Q1	37431.5
median	142508
Q3	170041.5
95-th percentile	181005.7
Maximum	187271
Range	174703
Interquartile range (IQR)	132610

Descriptive statistics

Standard deviation	63082.72992
Coefficient of variation (CV)	0.5417849935
Kurtosis	-1.272363107
Mean	116434.9893
Median Absolute Deviation (MAD)	32004
Skewness	-0.6477076819
Sum	2129246649
Variance	3979430814
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
174449	4	< 0.1%
174475	4	< 0.1%
174473	4	< 0.1%
174472	4	< 0.1%
174471	4	< 0.1%
174470	4	< 0.1%
174469	4	< 0.1%
174468	4	< 0.1%
174467	4	< 0.1%
174466	4	< 0.1%
Other values (17123)	18247	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12568	1	< 0.1%
12569	1	< 0.1%
12570	1	< 0.1%
12571	1	< 0.1%
12572	1	< 0.1%
12573	1	< 0.1%
12574	1	< 0.1%
12575	1	< 0.1%
12576	1	< 0.1%
12577	1	< 0.1%

Value	Count	Frequency (%)
187271	1	< 0.1%
187270	1	< 0.1%
187269	1	< 0.1%
187268	1	< 0.1%
187267	1	< 0.1%
187266	1	< 0.1%
187265	1	< 0.1%
187264	1	< 0.1%
187263	1	< 0.1%
187262	1	< 0.1%

linqmap_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	143.0 KiB

JAM	8387
ROAD_CLOSED	6685
WEATHERHAZARD	3023
ACCIDENT	192

Length

Max length	13
Median length	11
Mean length	7.630065074
Min length	3

Characters and Unicode

Total characters	139531
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	JAM
2nd row	WEATHERHAZARD
3rd row	JAM
4th row	ACCIDENT
5th row	JAM

Common Values

Value	Count	Frequency (%)
JAM	8387	45.9%
ROAD_CLOSED	6685	36.6%
WEATHERHAZARD	3023	16.5%
ACCIDENT	192	1.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
jam	8387	45.9%
road_closed	6685	36.6%
weatherhazard	3023	16.5%
accident	192	1.0%

Most occurring characters

Value	Count	Frequency (%)
A	24333	17.4%
D	16585	11.9%
O	13370	9.6%
E	12923	9.3%
R	12731	9.1%
J	8387	6.0%
M	8387	6.0%
C	7069	5.1%
S	6685	4.8%
L	6685	4.8%
Other values (7)	22376	16.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	132846	95.2%
Connector Punctuation	6685	4.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	24333	18.3%
D	16585	12.5%
O	13370	10.1%
E	12923	9.7%
R	12731	9.6%
J	8387	6.3%
M	8387	6.3%
C	7069	5.3%
S	6685	5.0%
L	6685	5.0%
Other values (6)	15691	11.8%

Connector Punctuation

Value	Count	Frequency (%)
_	6685	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	132846	95.2%
Common	6685	4.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	24333	18.3%
D	16585	12.5%
O	13370	10.1%
E	12923	9.7%
R	12731	9.6%
J	8387	6.3%
M	8387	6.3%
C	7069	5.3%
S	6685	5.0%
L	6685	5.0%
Other values (6)	15691	11.8%

Common

Value	Count	Frequency (%)
_	6685	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	139531	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	24333	17.4%
D	16585	11.9%
O	13370	9.6%
E	12923	9.3%
R	12731	9.1%
J	8387	6.0%
M	8387	6.0%
C	7069	5.1%
S	6685	4.8%
L	6685	4.8%
Other values (7)	22376	16.0%

linqmap_subtype
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	24
Distinct (%)	0.1%
Missing	907
Missing (%)	5.0%
Memory size	143.0 KiB

ROAD_CLOSED_EVENT	6630
JAM_STAND_STILL_TRAFFIC	4429
JAM_HEAVY_TRAFFIC	2285
HAZARD_ON_SHOULDER_CAR_STOPPED	1641
JAM_MODERATE_TRAFFIC	1100
Other values (19)	1295

Length

Max length	34
Median length	17
Mean length	20.51973533
Min length	14

Characters and Unicode

Total characters	356633
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	JAM_STAND_STILL_TRAFFIC
2nd row	HAZARD_ON_SHOULDER_CAR_STOPPED
3rd row	JAM_STAND_STILL_TRAFFIC
4th row	JAM_STAND_STILL_TRAFFIC
5th row	JAM_STAND_STILL_TRAFFIC

Common Values

Value	Count	Frequency (%)
ROAD_CLOSED_EVENT	6630	36.3%
JAM_STAND_STILL_TRAFFIC	4429	24.2%
JAM_HEAVY_TRAFFIC	2285	12.5%
HAZARD_ON_SHOULDER_CAR_STOPPED	1641	9.0%
JAM_MODERATE_TRAFFIC	1100	6.0%
HAZARD_ON_ROAD_CONSTRUCTION	605	3.3%
HAZARD_ON_ROAD_CAR_STOPPED	329	1.8%
HAZARD_WEATHER_FOG	100	0.5%
ACCIDENT_MINOR	48	0.3%
ROAD_CLOSED_CONSTRUCTION	40	0.2%
Other values (14)	173	0.9%
(Missing)	907	5.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
road_closed_event	6630	38.1%
jam_stand_still_traffic	4429	25.5%
jam_heavy_traffic	2285	13.1%
hazard_on_shoulder_car_stopped	1641	9.4%
jam_moderate_traffic	1100	6.3%
hazard_on_road_construction	605	3.5%
hazard_on_road_car_stopped	329	1.9%
hazard_weather_fog	100	0.6%
accident_minor	48	0.3%
road_closed_construction	40	0.2%
Other values (14)	173	1.0%

Most occurring characters

Value	Count	Frequency (%)
_	43833	12.3%
A	39018	10.9%
E	28426	8.0%
T	27968	7.8%
D	26446	7.4%
R	23927	6.7%
O	23403	6.6%
S	19852	5.6%
C	17966	5.0%
L	17277	4.8%
Other values (15)	88517	24.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	312800	87.7%
Connector Punctuation	43833	12.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	39018	12.5%
E	28426	9.1%
T	27968	8.9%
D	26446	8.5%
R	23927	7.6%
O	23403	7.5%
S	19852	6.3%
C	17966	5.7%
L	17277	5.5%
F	15775	5.0%
Other values (14)	72742	23.3%

Connector Punctuation

Value	Count	Frequency (%)
_	43833	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	312800	87.7%
Common	43833	12.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	39018	12.5%
E	28426	9.1%
T	27968	8.9%
D	26446	8.5%
R	23927	7.6%
O	23403	7.5%
S	19852	6.3%
C	17966	5.7%
L	17277	5.5%
F	15775	5.0%
Other values (14)	72742	23.3%

Common

Value	Count	Frequency (%)
_	43833	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	356633	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
_	43833	12.3%
A	39018	10.9%
E	28426	8.0%
T	27968	7.8%
D	26446	7.4%
R	23927	6.7%
O	23403	6.6%
S	19852	5.6%
C	17966	5.0%
L	17277	4.8%
Other values (15)	88517	24.8%

pubDate
Date

Distinct	9989
Distinct (%)	54.6%
Missing	0
Missing (%)	0.0%
Memory size	143.0 KiB

Minimum	2021-02-07 03:00:00
Maximum	2022-05-24 12:51:44

Histogram

Histogram with fixed size bins (bins=50)

linqmap_reportDescription
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	0.9%
Missing	17949
Missing (%)	98.2%
Memory size	143.0 KiB

חסר מידע	296
אתר התארגנות - הקו הירוק של הרכבת הקלה	37
עבודות-סגירה חלקית	5

Length

Max length	38
Median length	8
Mean length	11.43195266
Min length	8

Characters and Unicode

Total characters	3864
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	אתר התארגנות - הקו הירוק של הרכבת הקלה
2nd row	חסר מידע
3rd row	חסר מידע
4th row	חסר מידע
5th row	חסר מידע

Common Values

Value	Count	Frequency (%)
חסר מידע	296	1.6%
אתר התארגנות - הקו הירוק של הרכבת הקלה	37	0.2%
עבודות-סגירה חלקית	5	< 0.1%
(Missing)	17949	98.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
חסר	296	33.0%
מידע	296	33.0%
אתר	37	4.1%
התארגנות	37	4.1%
	37	4.1%
הקו	37	4.1%
הירוק	37	4.1%
של	37	4.1%
הרכבת	37	4.1%
הקלה	37	4.1%
Other values (2)	10	1.1%

Most occurring characters

Value	Count	Frequency (%)
	560	14.5%
ר	449	11.6%
י	343	8.9%
ח	301	7.8%
ס	301	7.8%
ד	301	7.8%
ע	301	7.8%
מ	296	7.7%
ה	227	5.9%
ת	158	4.1%
Other values (10)	627	16.2%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	3262	84.4%
Space Separator	560	14.5%
Dash Punctuation	42	1.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
ר	449	13.8%
י	343	10.5%
ח	301	9.2%
ס	301	9.2%
ד	301	9.2%
ע	301	9.2%
מ	296	9.1%
ה	227	7.0%
ת	158	4.8%
ו	121	3.7%
Other values (8)	464	14.2%

Space Separator

Value	Count	Frequency (%)
	560	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	42	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hebrew	3262	84.4%
Common	602	15.6%

Most frequent character per script

Hebrew

Value	Count	Frequency (%)
ר	449	13.8%
י	343	10.5%
ח	301	9.2%
ס	301	9.2%
ד	301	9.2%
ע	301	9.2%
מ	296	9.1%
ה	227	7.0%
ת	158	4.8%
ו	121	3.7%
Other values (8)	464	14.2%

Common

Value	Count	Frequency (%)
	560	93.0%
-	42	7.0%

Most occurring blocks

Value	Count	Frequency (%)
Hebrew	3262	84.4%
ASCII	602	15.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	560	93.0%
-	42	7.0%

Hebrew

Value	Count	Frequency (%)
ר	449	13.8%
י	343	10.5%
ח	301	9.2%
ס	301	9.2%
ד	301	9.2%
ע	301	9.2%
מ	296	9.1%
ה	227	7.0%
ת	158	4.8%
ו	121	3.7%
Other values (8)	464	14.2%

linqmap_city
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	77
Distinct (%)	0.7%
Missing	7850
Missing (%)	42.9%
Memory size	143.0 KiB

תל אביב - יפו	4502
אור יהודה	950
חולון	527
רמת גן	501
פתח תקווה	445
Other values (72)	3512

Length

Max length	23
Median length	19
Mean length	10.025103
Min length	3

Characters and Unicode

Total characters	104632
Distinct characters	38
Distinct categories	6 ?
Distinct scripts	4 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16 ?
Unique (%)	0.2%

Sample

1st row	פלמחים
2nd row	פתח תקווה
3rd row	גבעתיים
4th row	רמת גן
5th row	יהוד-מונוסון

Common Values

Value	Count	Frequency (%)
תל אביב - יפו	4502	24.6%
אור יהודה	950	5.2%
חולון	527	2.9%
רמת גן	501	2.7%
פתח תקווה	445	2.4%
יהוד-מונוסון	376	2.1%
ראשון לציון	351	1.9%
בני ברק	330	1.8%
רחובות	311	1.7%
בת ים	284	1.6%
Other values (67)	1860	10.2%
(Missing)	7850	42.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
תל	4507	16.2%
	4504	16.2%
יפו	4502	16.2%
אביב	4502	16.2%
יהודה	959	3.5%
אור	950	3.4%
רמת	711	2.6%
חולון	527	1.9%
גן	505	1.8%
תקווה	449	1.6%
Other values (101)	5656	20.4%

Most occurring characters

Value	Count	Frequency (%)
	17335	16.6%
י	12564	12.0%
ו	12348	11.8%
ב	10915	10.4%
ת	7386	7.1%
א	6488	6.2%
ל	5758	5.5%
פ	5248	5.0%
-	4988	4.8%
ה	3945	3.8%
Other values (28)	17657	16.9%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	82291	78.6%
Space Separator	17335	16.6%
Dash Punctuation	4988	4.8%
Lowercase Letter	14	< 0.1%
Uppercase Letter	2	< 0.1%
Other Punctuation	2	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
י	12564	15.3%
ו	12348	15.0%
ב	10915	13.3%
ת	7386	9.0%
א	6488	7.9%
ל	5758	7.0%
פ	5248	6.4%
ה	3945	4.8%
ר	3765	4.6%
ן	2587	3.1%
Other values (19)	11287	13.7%

Lowercase Letter

Value	Count	Frequency (%)
a	4	28.6%
l	4	28.6%
i	2	14.3%
y	2	14.3%
q	2	14.3%

Space Separator

Value	Count	Frequency (%)
	17335	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4988	100.0%

Uppercase Letter

Value	Count	Frequency (%)
Q	2	100.0%

Other Punctuation

Value	Count	Frequency (%)
"	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hebrew	82277	78.6%
Common	22325	21.3%
Latin	16	< 0.1%
Arabic	14	< 0.1%

Most frequent character per script

Hebrew

Value	Count	Frequency (%)
י	12564	15.3%
ו	12348	15.0%
ב	10915	13.3%
ת	7386	9.0%
א	6488	7.9%
ל	5758	7.0%
פ	5248	6.4%
ה	3945	4.8%
ר	3765	4.6%
ן	2587	3.1%
Other values (15)	11273	13.7%

Latin

Value	Count	Frequency (%)
a	4	25.0%
l	4	25.0%
i	2	12.5%
y	2	12.5%
q	2	12.5%
Q	2	12.5%

Arabic

Value	Count	Frequency (%)
ق	4	28.6%
ي	4	28.6%
ل	4	28.6%
ة	2	14.3%

Common

Value	Count	Frequency (%)
	17335	77.6%
-	4988	22.3%
"	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
Hebrew	82277	78.6%
ASCII	22341	21.4%
Arabic	14	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	17335	77.6%
-	4988	22.3%
a	4	< 0.1%
l	4	< 0.1%
i	2	< 0.1%
y	2	< 0.1%
q	2	< 0.1%
Q	2	< 0.1%
"	2	< 0.1%

Hebrew

Value	Count	Frequency (%)
י	12564	15.3%
ו	12348	15.0%
ב	10915	13.3%
ת	7386	9.0%
א	6488	7.9%
ל	5758	7.0%
פ	5248	6.4%
ה	3945	4.8%
ר	3765	4.6%
ן	2587	3.1%
Other values (15)	11273	13.7%

Arabic

Value	Count	Frequency (%)
ق	4	28.6%
ي	4	28.6%
ل	4	28.6%
ة	2	14.3%

linqmap_street
Categorical

HIGH CARDINALITY
MISSING

Distinct	1208
Distinct (%)	7.3%
Missing	1734
Missing (%)	9.5%
Memory size	143.0 KiB

שד ירושלים	911
6 דרום	617
4 דרום	510
4 צפון	464
בן יהודה	403
Other values (1203)	13648

Length

Max length	47
Median length	37
Mean length	8.545037153
Min length	1

Characters and Unicode

Total characters	141446
Distinct characters	46
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	426 ?
Unique (%)	2.6%

Sample

1st row	443 מערב
2nd row	ל-6 דרום
3rd row	בן גוריון
4th row	44 צפון
5th row	2 דרום

Common Values

Value	Count	Frequency (%)
שד ירושלים	911	5.0%
6 דרום	617	3.4%
4 דרום	510	2.8%
4 צפון	464	2.5%
בן יהודה	403	2.2%
יגאל אלון	382	2.1%
שתולים	326	1.8%
6 צפון	300	1.6%
20 איילון דרום	283	1.5%
ארלוזורוב	276	1.5%
Other values (1198)	12081	66.1%
(Missing)	1734	9.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
דרום	2211	6.9%
צפון	1684	5.2%
שד	1299	4.0%
ירושלים	1115	3.5%
4	998	3.1%
6	990	3.1%
מערב	930	2.9%
מזרח	786	2.4%
בן	784	2.4%
איילון	727	2.3%
Other values (1116)	20616	64.1%

Most occurring characters

Value	Count	Frequency (%)
	15587	11.0%
ו	13777	9.7%
י	12946	9.2%
ר	10671	7.5%
ל	8732	6.2%
ד	6566	4.6%
ן	5816	4.1%
ה	5500	3.9%
ב	5117	3.6%
ש	4952	3.5%
Other values (36)	51782	36.6%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	110882	78.4%
Space Separator	15587	11.0%
Decimal Number	11895	8.4%
Dash Punctuation	1612	1.1%
Other Punctuation	1050	0.7%
Open Punctuation	210	0.1%
Close Punctuation	210	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
ו	13777	12.4%
י	12946	11.7%
ר	10671	9.6%
ל	8732	7.9%
ד	6566	5.9%
ן	5816	5.2%
ה	5500	5.0%
ב	5117	4.6%
ש	4952	4.5%
א	4850	4.4%
Other values (17)	31955	28.8%

Decimal Number

Value	Count	Frequency (%)
4	3923	33.0%
1	1669	14.0%
2	1484	12.5%
6	1284	10.8%
0	1245	10.5%
5	1046	8.8%
3	724	6.1%
7	421	3.5%
8	92	0.8%
9	7	0.1%

Other Punctuation

Value	Count	Frequency (%)
,	752	71.6%
"	220	21.0%
/	48	4.6%
.	19	1.8%
׳	11	1.0%

Space Separator

Value	Count	Frequency (%)
	15587	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1612	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	210	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	210	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hebrew	110893	78.4%
Common	30553	21.6%

Most frequent character per script

Hebrew

Value	Count	Frequency (%)
ו	13777	12.4%
י	12946	11.7%
ר	10671	9.6%
ל	8732	7.9%
ד	6566	5.9%
ן	5816	5.2%
ה	5500	5.0%
ב	5117	4.6%
ש	4952	4.5%
א	4850	4.4%
Other values (18)	31966	28.8%

Common

Value	Count	Frequency (%)
	15587	51.0%
4	3923	12.8%
1	1669	5.5%
-	1612	5.3%
2	1484	4.9%
6	1284	4.2%
0	1245	4.1%
5	1046	3.4%
,	752	2.5%
3	724	2.4%
Other values (8)	1227	4.0%

Most occurring blocks

Value	Count	Frequency (%)
Hebrew	110893	78.4%
ASCII	30553	21.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	15587	51.0%
4	3923	12.8%
1	1669	5.5%
-	1612	5.3%
2	1484	4.9%
6	1284	4.2%
0	1245	4.1%
5	1046	3.4%
,	752	2.5%
3	724	2.4%
Other values (8)	1227	4.0%

Hebrew

Value	Count	Frequency (%)
ו	13777	12.4%
י	12946	11.7%
ר	10671	9.6%
ל	8732	7.9%
ד	6566	5.9%
ן	5816	5.2%
ה	5500	5.0%
ב	5117	4.6%
ש	4952	4.5%
א	4850	4.4%
Other values (18)	31966	28.8%

linqmap_nearby
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	18287
Missing (%)	100.0%
Memory size	143.0 KiB

linqmap_roadType
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.976540712

Minimum	0
Maximum	22
Zeros	333
Zeros (%)	1.8%
Negative	0
Negative (%)	0.0%
Memory size	143.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	3
95-th percentile	6
Maximum	22
Range	22
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.630400269
Coefficient of variation (CV)	0.8837104961
Kurtosis	18.2604061
Mean	2.976540712
Median Absolute Deviation (MAD)	1
Skewness	3.733319605
Sum	54432
Variance	6.919005576
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
2	6767	37.0%
3	3783	20.7%
1	3239	17.7%
4	1725	9.4%
6	1613	8.8%
7	451	2.5%
0	333	1.8%
17	235	1.3%
20	95	0.5%
16	37	0.2%
Other values (3)	9	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	333	1.8%
1	3239	17.7%
2	6767	37.0%
3	3783	20.7%
4	1725	9.4%
6	1613	8.8%
7	451	2.5%
8	7	< 0.1%
10	1	< 0.1%
16	37	0.2%

Value	Count	Frequency (%)
22	1	< 0.1%
20	95	0.5%
17	235	1.3%
16	37	0.2%
10	1	< 0.1%
8	7	< 0.1%
7	451	2.5%
6	1613	8.8%
4	1725	9.4%
3	3783	20.7%

linqmap_reportMood
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	143.0 KiB

0	18287

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	18287
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	18287	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	18287	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	18287	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18287	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	18287	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	18287	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	18287	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18287	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	18287	100.0%

linqmap_reportRating
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.993656696

Minimum	0
Maximum	5
Zeros	7011
Zeros (%)	38.3%
Negative	0
Negative (%)	0.0%
Memory size	143.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	5
Q3	5
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.411659855
Coefficient of variation (CV)	0.8055899858
Kurtosis	-1.808449111
Mean	2.993656696
Median Absolute Deviation (MAD)	0
Skewness	-0.4054205895
Sum	54745
Variance	5.816103258
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
5	10558	57.7%
0	7011	38.3%
4	251	1.4%
3	178	1.0%
1	161	0.9%
2	128	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7011	38.3%
1	161	0.9%
2	128	0.7%
3	178	1.0%
4	251	1.4%
5	10558	57.7%

Value	Count	Frequency (%)
5	10558	57.7%
4	251	1.4%
3	178	1.0%
2	128	0.7%
1	161	0.9%
0	7011	38.3%

linqmap_expectedBeginDate
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	18287
Missing (%)	100.0%
Memory size	143.0 KiB

linqmap_expectedEndDate
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	18287
Missing (%)	100.0%
Memory size	143.0 KiB

linqmap_magvar
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	360
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	106.6642424

Minimum	0
Maximum	359
Zeros	7086
Zeros (%)	38.7%
Negative	0
Negative (%)	0.0%
Memory size	143.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	42
Q3	201
95-th percentile	327
Maximum	359
Range	359
Interquartile range (IQR)	201

Descriptive statistics

Standard deviation	118.5412674
Coefficient of variation (CV)	1.11134964
Kurtosis	-1.062369076
Mean	106.6642424
Median Absolute Deviation (MAD)	42
Skewness	0.6341564302
Sum	1950569
Variance	14052.03207
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7086	38.7%
359	136	0.7%
9	117	0.6%
8	111	0.6%
192	101	0.6%
190	100	0.5%
191	93	0.5%
201	93	0.5%
200	87	0.5%
195	86	0.5%
Other values (350)	10277	56.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7086	38.7%
1	42	0.2%
2	52	0.3%
3	56	0.3%
4	49	0.3%
5	40	0.2%
6	69	0.4%
7	55	0.3%
8	111	0.6%
9	117	0.6%

Value	Count	Frequency (%)
359	136	0.7%
358	47	0.3%
357	48	0.3%
356	33	0.2%
355	44	0.2%
354	51	0.3%
353	27	0.1%
352	32	0.2%
351	50	0.3%
350	32	0.2%

nComments
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	143.0 KiB

0	18287

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	18287
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	18287	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	18287	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	18287	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18287	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	18287	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	18287	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	18287	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18287	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	18287	100.0%

linqmap_reliability
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.315579373

Minimum	5
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	143.0 KiB

Quantile statistics

Minimum	5
5-th percentile	5
Q1	5
median	6
Q3	10
95-th percentile	10
Maximum	10
Range	5
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.094243913
Coefficient of variation (CV)	0.2862717778
Kurtosis	-1.646556163
Mean	7.315579373
Median Absolute Deviation (MAD)	1
Skewness	0.2765046277
Sum	133780
Variance	4.385857565
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
10	6007	32.8%
5	5095	27.9%
6	4224	23.1%
7	1392	7.6%
8	974	5.3%
9	595	3.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	5095	27.9%
6	4224	23.1%
7	1392	7.6%
8	974	5.3%
9	595	3.3%
10	6007	32.8%

Value	Count	Frequency (%)
10	6007	32.8%
9	595	3.3%
8	974	5.3%
7	1392	7.6%
6	4224	23.1%
5	5095	27.9%

update_date
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	5135
Distinct (%)	28.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.652874385 × 10¹²

Minimum	1.652608382 × 10¹²
Maximum	1.653396783 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	143.0 KiB

Quantile statistics

Minimum	1.652608382 × 10¹²
5-th percentile	1.652622782 × 10¹²
Q1	1.652781183 × 10¹²
median	1.652813583 × 10¹²
Q3	1.652860383 × 10¹²
95-th percentile	1.653389583 × 10¹²
Maximum	1.653396783 × 10¹²
Range	788400312
Interquartile range (IQR)	79200108

Descriptive statistics

Standard deviation	227760498.5
Coefficient of variation (CV)	0.0001377966169
Kurtosis	1.125945313
Mean	1.652874385 × 10¹²
Median Absolute Deviation (MAD)	32400100
Skewness	1.523369388
Sum	3.022611388 × 10¹⁶
Variance	5.187484467 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.652839383 × 10¹²	28	0.2%
1.652839383 × 10¹²	28	0.2%
1.652839383 × 10¹²	28	0.2%
1.652839383 × 10¹²	28	0.2%
1.652839383 × 10¹²	28	0.2%
1.652863983 × 10¹²	27	0.1%
1.652629982 × 10¹²	25	0.1%
1.652817182 × 10¹²	25	0.1%
1.652629982 × 10¹²	25	0.1%
1.652839384 × 10¹²	24	0.1%
Other values (5125)	18021	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.652608382 × 10¹²	1	< 0.1%
1.652608382 × 10¹²	1	< 0.1%
1.652608382 × 10¹²	3	< 0.1%
1.652608382 × 10¹²	4	< 0.1%
1.652608382 × 10¹²	1	< 0.1%
1.652608382 × 10¹²	1	< 0.1%
1.652608382 × 10¹²	7	< 0.1%
1.652608382 × 10¹²	3	< 0.1%
1.652608382 × 10¹²	4	< 0.1%
1.652608382 × 10¹²	3	< 0.1%

Value	Count	Frequency (%)
1.653396783 × 10¹²	6	< 0.1%
1.653396783 × 10¹²	3	< 0.1%
1.653396783 × 10¹²	3	< 0.1%
1.653396783 × 10¹²	6	< 0.1%
1.653396783 × 10¹²	7	< 0.1%
1.653396783 × 10¹²	3	< 0.1%
1.653396783 × 10¹²	3	< 0.1%
1.653396783 × 10¹²	3	< 0.1%
1.653396783 × 10¹²	6	< 0.1%
1.653396783 × 10¹²	4	< 0.1%

x
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	11272
Distinct (%)	61.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	184336.3311

Minimum	164717.1
Maximum	201742.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	143.0 KiB

Quantile statistics

Minimum	164717.1
5-th percentile	177015.08
Q1	179115.53
median	183245.84
Q3	187908.905
95-th percentile	196673.437
Maximum	201742.85
Range	37025.75
Interquartile range (IQR)	8793.375

Descriptive statistics

Standard deviation	6507.341846
Coefficient of variation (CV)	0.03530146123
Kurtosis	0.03644758349
Mean	184336.3311
Median Absolute Deviation (MAD)	4246.8
Skewness	0.561943231
Sum	3370958487
Variance	42345497.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
178825.86	259	1.4%
186260.92	79	0.4%
186255.74	79	0.4%
178747.04	75	0.4%
178578.92	74	0.4%
188285.59	74	0.4%
187667.67	74	0.4%
178618.18	74	0.4%
180770.3	74	0.4%
180759.68	74	0.4%
Other values (11262)	17351	94.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
164717.1	1	< 0.1%
165786.41	1	< 0.1%
165871.71	1	< 0.1%
166117.21	1	< 0.1%
166276.83	1	< 0.1%
166287.49	1	< 0.1%
166495.29	1	< 0.1%
166532.14	1	< 0.1%
166600.81	9	< 0.1%
166639.4	9	< 0.1%

Value	Count	Frequency (%)
201742.85	5	< 0.1%
201712.18	1	< 0.1%
201708.6	1	< 0.1%
201682.37	1	< 0.1%
201680.23	1	< 0.1%
201671.46	1	< 0.1%
201669.39	1	< 0.1%
201664.88	1	< 0.1%
201662.39	1	< 0.1%
201661.35	1	< 0.1%

y
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	11286
Distinct (%)	61.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	663304.8278

Minimum	630669.73
Maximum	696807.08
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	143.0 KiB

Quantile statistics

Minimum	630669.73
5-th percentile	643831.779
Q1	658984.21
median	663036.88
Q3	667294.345
95-th percentile	687481.238
Maximum	696807.08
Range	66137.35
Interquartile range (IQR)	8310.135

Descriptive statistics

Standard deviation	11515.93411
Coefficient of variation (CV)	0.01736145077
Kurtosis	1.274724882
Mean	663304.8278
Median Absolute Deviation (MAD)	4135.11
Skewness	0.2063734448
Sum	1.212985539 × 10¹⁰
Variance	132616738.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
665089.18	259	1.4%
659751.11	79	0.4%
659726.96	79	0.4%
665885.89	74	0.4%
659530.06	74	0.4%
665686.46	74	0.4%
659861.01	74	0.4%
662145.52	74	0.4%
661531.87	74	0.4%
666085.19	74	0.4%
Other values (11276)	17352	94.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
630669.73	1	< 0.1%
630707.13	1	< 0.1%
630854.48	1	< 0.1%
630961.16	1	< 0.1%
631051.27	1	< 0.1%
631091.64	1	< 0.1%
631151.58	1	< 0.1%
631293.71	1	< 0.1%
631389.77	1	< 0.1%
631395.03	1	< 0.1%

Value	Count	Frequency (%)
696807.08	1	< 0.1%
696805.16	1	< 0.1%
696800.44	1	< 0.1%
696745.11	1	< 0.1%
696685.14	1	< 0.1%
696683.3	1	< 0.1%
696636.3	1	< 0.1%
696630.97	1	< 0.1%
696613.1	1	< 0.1%
696606.38	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	OBJECTID	linqmap_type	linqmap_subtype	pubDate	linqmap_reportDescription	linqmap_city	linqmap_street	linqmap_nearby	linqmap_roadType	linqmap_reportRating	linqmap_expectedBeginDate	linqmap_expectedEndDate	linqmap_magvar	linqmap_reliability	update_date	x	y
0	16519	JAM	JAM_STAND_STILL_TRAFFIC	2022-05-15 09:31:17	NaN	NaN	443 מערב	NaN	6	5	NaN	NaN	272	7	1652608382307	197236.32	650361.57
1	16520	WEATHERHAZARD	HAZARD_ON_SHOULDER_CAR_STOPPED	2022-05-15 09:43:09	NaN	פלמחים	NaN	NaN	2	5	NaN	NaN	174	6	1652608382309	173578.82	649010.73
2	16521	JAM	JAM_STAND_STILL_TRAFFIC	2022-05-15 09:40:57	NaN	NaN	ל-6 דרום	NaN	4	5	NaN	NaN	209	7	1652608382310	196444.19	679037.74
3	16522	ACCIDENT	NaN	2022-05-15 09:28:38	NaN	פתח תקווה	NaN	NaN	20	5	NaN	NaN	60	5	1652608382310	189858.74	668371.12
4	16523	JAM	JAM_STAND_STILL_TRAFFIC	2022-05-15 09:37:25	NaN	גבעתיים	בן גוריון	NaN	2	5	NaN	NaN	13	6	1652608382310	183121.44	665120.96
5	16524	JAM	JAM_STAND_STILL_TRAFFIC	2022-05-15 09:50:03	NaN	NaN	44 צפון	NaN	6	5	NaN	NaN	292	5	1652608382311	188724.04	648404.31
6	16525	JAM	JAM_STAND_STILL_TRAFFIC	2022-05-15 09:19:19	NaN	NaN	2 דרום	NaN	3	5	NaN	NaN	198	7	1652608382311	188532.73	694510.08
7	16526	ROAD_CLOSED	ROAD_CLOSED_EVENT	2022-04-05 09:56:53	NaN	רמת גן	תלפיות	NaN	1	0	NaN	NaN	0	10	1652608382311	182329.61	665960.52
8	16527	WEATHERHAZARD	HAZARD_ON_SHOULDER_CAR_STOPPED	2022-05-15 09:50:53	NaN	NaN	6 דרום	NaN	3	5	NaN	NaN	198	10	1652608382311	198699.39	683382.25
9	16528	JAM	JAM_HEAVY_TRAFFIC	2022-05-15 09:21:10	NaN	NaN	2 דרום	NaN	3	5	NaN	NaN	153	9	1652608382312	188666.85	695586.66

Last rows

	OBJECTID	linqmap_type	linqmap_subtype	pubDate	linqmap_reportDescription	linqmap_city	linqmap_street	linqmap_nearby	linqmap_roadType	linqmap_reportRating	linqmap_expectedBeginDate	linqmap_expectedEndDate	linqmap_magvar	linqmap_reliability	update_date	x	y
18277	25693	ROAD_CLOSED	ROAD_CLOSED_EVENT	2022-01-04 21:37:08	NaN	אור יהודה	יגאל אלון	NaN	2	0	NaN	NaN	0	6	1653396782617	186214.39	659530.06
18278	25694	JAM	JAM_HEAVY_TRAFFIC	2022-05-24 12:34:15	NaN	ראשון לציון	אליהו איתן	NaN	1	5	NaN	NaN	114	5	1653396782618	177869.94	655568.57
18279	25695	JAM	JAM_STAND_STILL_TRAFFIC	2022-05-24 12:39:39	NaN	גני עם	הבנים	NaN	2	5	NaN	NaN	244	5	1653396782618	190578.65	673141.42
18280	25696	JAM	JAM_STAND_STILL_TRAFFIC	2022-05-24 12:37:21	NaN	פתח תקווה	רוטשילד	NaN	2	5	NaN	NaN	185	6	1653396782618	188891.30	666391.81
18281	25697	ROAD_CLOSED	ROAD_CLOSED_EVENT	2022-05-17 12:38:22	NaN	תל אביב - יפו	שתולים	NaN	1	0	NaN	NaN	0	8	1653396782619	180794.64	661410.20
18282	25698	ROAD_CLOSED	ROAD_CLOSED_EVENT	2022-05-15 17:00:03	NaN	רחובות	NaN	NaN	1	0	NaN	NaN	0	10	1653396782619	178853.06	645047.15
18283	25699	ROAD_CLOSED	ROAD_CLOSED_EVENT	2022-01-04 21:37:10	NaN	אור יהודה	יגאל אלון	NaN	2	0	NaN	NaN	0	10	1653396782619	186260.92	659751.11
18284	25700	WEATHERHAZARD	HAZARD_ON_SHOULDER_CAR_STOPPED	2022-05-24 12:50:42	NaN	NaN	444 צפון	NaN	6	5	NaN	NaN	0	5	1653396782619	194659.70	651846.50
18285	25701	JAM	JAM_STAND_STILL_TRAFFIC	2022-05-24 12:27:39	NaN	NaN	5504	NaN	7	5	NaN	NaN	194	5	1653396782619	196156.07	678754.28
18286	25702	JAM	JAM_STAND_STILL_TRAFFIC	2022-05-24 12:36:25	NaN	NaN	4 דרום	NaN	3	5	NaN	NaN	193	6	1653396782619	185775.79	667532.36

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Hebrew

Common

Most occurring blocks

Most frequent character per block

ASCII

Hebrew

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Lowercase Letter

Space Separator

Dash Punctuation

Uppercase Letter

Other Punctuation

Most occurring scripts

Most frequent character per script

Hebrew

Latin

Arabic

Common

Most occurring blocks

Most frequent character per block

ASCII

Hebrew

Arabic

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation